-- 开始初始化数据 ;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

BEGIN;
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menulist', 'GET', NULL, NULL, NULL, 710, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu', 'POST', NULL, NULL, NULL, 711, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu', 'PUT', NULL, NULL, NULL, 712, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu/:id', 'DELETE', NULL, NULL, NULL, 713, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/sysUserList', 'GET', NULL, NULL, NULL, 714, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/sysUser/:id', 'GET', NULL, NULL, NULL, 715, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/sysUser/', 'GET', NULL, NULL, NULL, 716, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/sysUser', 'POST', NULL, NULL, NULL, 717, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/sysUser', 'PUT', NULL, NULL, NULL, 718, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/sysUser/:id', 'DELETE', NULL, NULL, NULL, 719, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/user/profile', 'GET', NULL, NULL, NULL, 720, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/rolelist', 'GET', NULL, NULL, NULL, 721, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/role/:id', 'GET', NULL, NULL, NULL, 722, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/role', 'POST', NULL, NULL, NULL, 723, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/role', 'PUT', NULL, NULL, NULL, 724, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/role/:id', 'DELETE', NULL, NULL, NULL, 725, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menurole', 'GET', NULL, NULL, NULL, 726, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/roleMenuTreeselect/:id', 'GET', NULL, NULL, NULL, 727, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menuTreeselect', 'GET', NULL, NULL, NULL, 728, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/deptList', 'GET', NULL, NULL, NULL, 729, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/dept/:id', 'GET', NULL, NULL, NULL, 730, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/dept', 'POST', NULL, NULL, NULL, 731, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/dept', 'PUT', NULL, NULL, NULL, 732, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/dept/:id', 'DELETE', NULL, NULL, NULL, 733, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/postlist', 'GET', NULL, NULL, NULL, 734, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/post/:id', 'GET', NULL, NULL, NULL, 735, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/post', 'POST', NULL, NULL, NULL, 736, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/post', 'PUT', NULL, NULL, NULL, 737, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/post/:id', 'DELETE', NULL, NULL, NULL, 738, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menulist', 'GET', NULL, NULL, NULL, 739, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu/:id', 'GET', NULL, NULL, NULL, 740, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu', 'POST', NULL, NULL, NULL, 741, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu/:id', 'PUT', NULL, NULL, NULL, 742, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menu/:id', 'DELETE', NULL, NULL, NULL, 743, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/menuids', 'GET', NULL, NULL, NULL, 744, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/loginloglist', 'GET', NULL, NULL, NULL, 745, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/loginlog/:id', 'DELETE', NULL, NULL, NULL, 746, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/getinfo', 'GET', NULL, NULL, NULL, 747, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/roleDeptTreeselect/:id', 'GET', NULL, NULL, NULL, 748, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/deptTree', 'GET', NULL, NULL, NULL, 749, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/logout', 'POST', NULL, NULL, NULL, 750, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/user/avatar', 'POST', NULL, NULL, NULL, 751, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/user/pwd', 'PUT', NULL, NULL, NULL, 752, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/dashboard', 'GET', NULL, NULL, NULL, 753, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/settings', 'POST', NULL, NULL, NULL, 754, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/settings', 'GET', NULL, NULL, NULL, 755, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/loginlog', 'DELETE', NULL, NULL, NULL, 756, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/monitor/server', 'GET', NULL, NULL, NULL, 757, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/classify', 'POST', NULL, NULL, NULL, 758, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/classify', 'GET', NULL, NULL, NULL, 759, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/classify', 'PUT', NULL, NULL, NULL, 760, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'admin', '/api/v1/classify', 'DELETE', NULL, NULL, NULL, 761, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/user/profile', 'GET', NULL, NULL, NULL, 814, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/menurole', 'GET', NULL, NULL, NULL, 815, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/menuTreeselect', 'GET', NULL, NULL, NULL, 816, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/menuids', 'GET', NULL, NULL, NULL, 817, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/getinfo', 'GET', NULL, NULL, NULL, 818, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/roleDeptTreeselect/:id', 'GET', NULL, NULL, NULL, 819, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/deptTree', 'GET', NULL, NULL, NULL, 820, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/logout', 'POST', NULL, NULL, NULL, 821, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/user/avatar', 'POST', NULL, NULL, NULL, 822, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/user/pwd', 'PUT', NULL, NULL, NULL, 823, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/dashboard', 'GET', NULL, NULL, NULL, 824, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/monitor/server', 'GET', NULL, NULL, NULL, 825, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/classify', 'POST', NULL, NULL, NULL, 826, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/classify', 'GET', NULL, NULL, NULL, 827, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/classify', 'PUT', NULL, NULL, NULL, 828, NULL, NULL, NULL);
INSERT INTO `casbin_rule` VALUES ('p', 'common', '/api/v1/classify', 'DELETE', NULL, NULL, NULL, 829, NULL, NULL, NULL);
COMMIT;

BEGIN;
INSERT INTO `p_process_classify` VALUES (1, '2020-10-28 11:13:56', '2020-10-28 15:08:46', NULL, 'vic', 1);
INSERT INTO `p_process_classify` VALUES (2, '2020-10-28 11:28:33', '2020-10-28 14:18:29', NULL, 'gg', 1);
INSERT INTO `p_process_classify` VALUES (3, '2020-10-28 13:47:25', '2020-10-28 13:47:25', NULL, 'pp', 3);
COMMIT;

BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, '/0/1', 'Ferry 科技', 0, 1, '', 'qq@qq.com', 0, '1', '1', NULL, '2020-10-28 15:02:36', NULL);
INSERT INTO `sys_dept` VALUES (7, 1, '/0/1/7', '研发部', 1, NULL, '', '', 0, '1', '1', NULL, NULL, NULL);
INSERT INTO `sys_dept` VALUES (8, 1, '/0/1/8', '运维部', 2, NULL, '', '', 0, '1', NULL, NULL, NULL, NULL);
INSERT INTO `sys_dept` VALUES (9, 1, '/0/1/9', '客服部', 3, NULL, '', '', 0, '1', NULL, NULL, NULL, NULL);
COMMIT;

BEGIN;
INSERT INTO `sys_menu` VALUES (2, 'Upms', '系统管理', 'example', '/upms', '/0/2', 'M', '无', '', 0, '1', '', 'Layout', 20, '0', '1', '11', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (3, 'Sysuser', '用户管理', 'user', 'sysuser', '/0/2/3', 'C', '无', 'system:sysuser:list', 2, NULL, NULL, '/system/sysuser/index', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (43, NULL, '新增用户', NULL, '/api/v1/sysuser', '/0/2/3/43', 'F', 'POST', 'system:sysuser:add', 3, NULL, NULL, NULL, 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (44, NULL, '查询用户', NULL, '/api/v1/sysuser', '/0/2/3/44', 'F', 'GET', 'system:sysuser:query', 3, NULL, NULL, NULL, 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (45, NULL, '修改用户', NULL, '/api/v1/sysuser/', '/0/2/3/45', 'F', 'PUT', 'system:sysuser:edit', 3, NULL, NULL, NULL, 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (46, NULL, '删除用户', NULL, '/api/v1/sysuser/', '/0/2/3/46', 'F', 'DELETE', 'system:sysuser:remove', 3, NULL, NULL, NULL, 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (51, 'Menu', '菜单管理', 'tree-table', 'menu', '/0/2/51', 'C', '无', 'system:sysmenu:list', 2, '1', '', '/system/menu/index', 5, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (52, 'Role', '角色管理', 'peoples', 'role', '/0/2/52', 'C', '无', 'system:sysrole:list', 2, '1', '', '/system/role/index', 2, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (56, 'Dept', '部门管理', 'tree', 'dept', '/0/2/56', 'C', '无', 'system:sysdept:list', 2, '0', '', '/system/dept/index', 4, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (57, 'post', '岗位管理', 'pass', 'post', '/0/2/57', 'C', '无', 'system:syspost:list', 2, '0', '', '/system/post/index', 3, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (63, '', '接口权限', 'bug', '', '/0/63', 'M', '', '', 0, '0', '', '', 99, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (64, '', '用户管理', 'user', '', '/0/63/280/64', 'M', '', '', 280, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (66, '', '菜单管理', 'tree-table', '', '/0/63/280/66', 'C', '', '', 280, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (67, '', '菜单列表', 'tree-table', '/api/v1/menulist', '/0/63/66/67', 'A', 'GET', '', 66, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (68, '', '新建菜单', 'tree', '/api/v1/menu', '/0/63/66/68', 'A', 'POST', '', 66, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (72, '', '修改菜单', 'bug', '/api/v1/menu', '/0/63/66/72', 'A', 'PUT', '', 66, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (73, '', '删除菜单', 'bug', '/api/v1/menu/:id', '/0/63/66/73', 'A', 'DELETE', '', 66, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (74, NULL, '管理员列表', 'bug', '/api/v1/sysUserList', '/0/63/64/74', 'A', 'GET', NULL, 64, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (75, NULL, '根据id获取管理员', 'bug', '/api/v1/sysUser/:id', '/0/63/64/75', 'A', 'GET', NULL, 64, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (76, NULL, '获取管理员', 'bug', '/api/v1/sysUser/', '/0/63/64/76', 'A', 'GET', NULL, 64, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (77, NULL, '创建管理员', 'bug', '/api/v1/sysUser', '/0/63/64/77', 'A', 'POST', NULL, 64, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (78, NULL, '修改管理员', 'bug', '/api/v1/sysUser', '/0/63/64/78', 'A', 'PUT', NULL, 64, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (79, NULL, '删除管理员', 'bug', '/api/v1/sysUser/:id', '/0/63/64/79', 'A', 'DELETE', NULL, 64, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (80, NULL, '当前用户个人信息', 'bug', '/api/v1/user/profile', '/0/63/256/267/80', 'A', 'GET', NULL, 267, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (81, NULL, '角色列表', 'bug', '/api/v1/rolelist', '/0/63/201/81', 'A', 'GET', NULL, 201, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (82, NULL, '获取角色信息', 'bug', '/api/v1/role/:id', '/0/63/201/82', 'A', 'GET', NULL, 201, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (83, NULL, '创建角色', 'bug', '/api/v1/role', '/0/63/201/83', 'A', 'POST', NULL, 201, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (84, NULL, '修改角色', 'bug', '/api/v1/role', '/0/63/201/84', 'A', 'PUT', NULL, 201, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (85, NULL, '删除角色', 'bug', '/api/v1/role/:id', '/0/63/201/85', 'A', 'DELETE', NULL, 201, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (92, NULL, '获取角色菜单', 'bug', '/api/v1/menurole', '/0/63/256/92', 'A', 'GET', NULL, 256, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-09-27 22:46:35', NULL);
INSERT INTO `sys_menu` VALUES (93, NULL, '根据角色id获取角色', 'bug', '/api/v1/roleMenuTreeselect/:id', '/0/63/201/93', 'A', 'GET', NULL, 201, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (94, NULL, '获取菜单树', 'bug', '/api/v1/menuTreeselect', '/0/63/256/94', 'A', 'GET', NULL, 256, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (103, NULL, '部门菜单列表', 'bug', '/api/v1/deptList', '/0/63/203/103', 'A', 'GET', NULL, 203, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (104, NULL, '根据id获取部门信息', 'bug', '/api/v1/dept/:id', '/0/63/203/104', 'A', 'GET', NULL, 203, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (105, NULL, '创建部门', 'bug', '/api/v1/dept', '/0/63/203/105', 'A', 'POST', NULL, 203, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (106, NULL, '修改部门', 'bug', '/api/v1/dept', '/0/63/203/106', 'A', 'PUT', NULL, 203, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (107, NULL, '删除部门', 'bug', '/api/v1/dept/:id', '/0/63/203/107', 'A', 'DELETE', NULL, 203, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (119, NULL, '获取岗位列表', 'bug', '/api/v1/postlist', '/0/63/204/119', 'A', 'GET', NULL, 204, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (120, NULL, '通过id获取岗位信息', 'bug', '/api/v1/post/:id', '/0/63/204/120', 'A', 'GET', NULL, 204, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (121, NULL, '创建岗位', 'bug', '/api/v1/post', '/0/63/204/121', 'A', 'POST', NULL, 204, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (122, NULL, '修改岗位', 'bug', '/api/v1/post', '/0/63/204/122', 'A', 'PUT', NULL, 204, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (123, NULL, '删除岗位', 'bug', '/api/v1/post/:id', '/0/63/204/123', 'A', 'DELETE', NULL, 204, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (137, NULL, '菜单列表', 'bug', '/api/v1/menulist', '/0/63/66/137', 'A', 'GET', NULL, 66, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (138, NULL, '获取根据id菜单信息', 'bug', '/api/v1/menu/:id', '/0/63/66/138', 'A', 'GET', NULL, 66, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (139, NULL, '创建菜单', 'bug', '/api/v1/menu', '/0/63/66/139', 'A', 'POST', NULL, 66, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (140, NULL, '修改菜单', 'bug', '/api/v1/menu/:id', '/0/63/66/140', 'A', 'PUT', NULL, 66, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (141, NULL, '删除菜单', 'bug', '/api/v1/menu/:id', '', 'A', 'DELETE', NULL, 66, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (142, NULL, '获取角色对应的菜单id数组', 'bug', '/api/v1/menuids', '/0/63/256/142', 'A', 'GET', NULL, 256, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (201, '', '角色管理', 'peoples', '', '/0/63/280/201', 'C', 'GET', '', 280, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (203, '', '部门管理', 'tree', '', '/0/63/280/203', 'C', 'POST', '', 280, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (204, '', '岗位管理', 'pass', '', '/0/63/280/204', 'C', '', '', 280, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (212, 'LoginLog', '登录日志', 'logininfor', '/loginlog', '/0/2/212', 'C', '', 'system:sysloginlog:list', 2, '0', '', '/system/loginlog/index', 6, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-08-18 23:07:15', NULL);
INSERT INTO `sys_menu` VALUES (213, NULL, '获取登录日志', 'bug', '/api/v1/loginloglist', '/0/63/214/213', 'A', 'GET', NULL, 214, NULL, NULL, NULL, 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (214, '', '日志管理', 'log', '', '/0/63/280/214', 'M', 'GET', '', 280, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (215, '', '删除日志', 'bug', '/api/v1/loginlog/:id', '/0/63/214/215', 'A', 'DELETE', '', 214, '0', '', '', 1, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (220, '', '新增菜单', '', '', '/0/2/51/220', 'F', '', 'system:sysmenu:add', 51, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (221, '', '修改菜单', 'edit', '', '/0/2/51/221', 'F', '', 'system:sysmenu:edit', 51, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (222, '', '查询菜单', 'search', '', '/0/2/51/222', 'F', '', 'system:sysmenu:query', 51, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (223, '', '删除菜单', '', '', '/0/2/51/223', 'F', '', 'system:sysmenu:remove', 51, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (224, '', '新增角色', '', '', '/0/2/52/224', 'F', '', 'system:sysrole:add', 52, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (225, '', '查询角色', '', '', '/0/2/52/225', 'F', '', 'system:sysrole:query', 52, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (226, '', '修改角色', '', '', '/0/2/52/226', 'F', '', 'system:sysrole:edit', 52, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (227, '', '删除角色', '', '', '/0/2/52/227', 'F', '', 'system:sysrole:remove', 52, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (228, '', '查询部门', '', '', '/0/2/56/228', 'F', '', 'system:sysdept:query', 56, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (229, '', '新增部门', '', '', '/0/2/56/229', 'F', '', 'system:sysdept:add', 56, '0', '', '', 1, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (230, '', '修改部门', '', '', '/0/2/56/230', 'F', '', 'system:sysdept:edit', 56, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (231, '', '删除部门', '', '', '/0/2/56/231', 'F', '', 'system:sysdept:remove', 56, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (232, '', '查询岗位', '', '', '/0/2/57/232', 'F', '', 'system:syspost:query', 57, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (233, '', '新增岗位', '', '', '/0/2/57/233', 'F', '', 'system:syspost:add', 57, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (234, '', '修改岗位', '', '', '/0/2/57/234', 'F', '', 'system:syspost:edit', 57, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (235, '', '删除岗位', '', '', '/0/2/57/235', 'F', '', 'system:syspost:remove', 57, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (244, '', '查询参数', '', '', '/0/2/62/244', 'F', '', 'system:sysconfig:query', 62, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (245, '', '新增参数', '', '', '/0/2/62/245', 'F', '', 'system:sysconfig:add', 62, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (246, '', '修改参数', '', '', '/0/2/62/246', 'F', '', 'system:sysconfig:edit', 62, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (247, '', '删除参数', '', '', '/0/2/62/247', 'F', '', 'system:sysconfig:remove', 62, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (248, '', '查询登录日志', '', '', '/0/2/211/212/248', 'F', '', 'system:sysloginlog:query', 212, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (249, '', '删除登录日志', '', '', '/0/2/211/212/249', 'F', '', 'system:sysloginlog:remove', 212, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (250, '', '查询操作日志', '', '', '/0/2/211/216/250', 'F', '', 'system:sysoperlog:query', 216, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (251, '', '删除操作日志', '', '', '/0/2/211/216/251', 'F', '', 'system:sysoperlog:remove', 216, '0', '', '', 0, '0', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (252, '', '获取登录用户信息', '', '/api/v1/getinfo', '/0/63/256/252', 'A', 'GET', '', 256, '0', '', '', 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (254, '', '部门树接口【数据权限】', '', '/api/v1/roleDeptTreeselect/:id', '/0/63/256/254', 'A', 'GET', '', 256, '0', '', '', 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (255, '', '部门树【用户列表】', '', '/api/v1/deptTree', '/0/63/256/255', 'A', 'GET', '', 256, '0', '', '', 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (256, '', '必开接口', 'vip', '', '/0/63/256', 'M', 'GET', '', 63, '0', '', '', 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-10-28 10:58:33', NULL);
INSERT INTO `sys_menu` VALUES (258, '', '退出登录', '', '/api/v1/logout', '/0/63/256/258', 'A', 'POST', '', 256, '0', '', '', 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (259, '', '头像上传', '', '/api/v1/user/avatar', '/0/63/256/267/259', 'A', 'POST', '', 267, '0', '', '', 0, '1', '1', '1', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (260, '', '修改密码', '', '/api/v1/user/pwd', '/0/63/256/260', 'A', 'PUT', '', 256, '0', '', '', 0, '1', '1', '', 0, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (267, '', '个人中心', '', '', '/0/63/256/267', 'M', '', '', 256, '0', '', '', 0, '1', '1', '', 1, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (280, '', '系统管理', 'calendar', '', '/0/63/280', 'M', '', '', 63, '0', '', '', 10, '1', '1', '1', 1, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (344, '', '首页数据', '', '/api/v1/dashboard', '/0/63/256/344', 'A', 'GET', '', 256, '0', '', '', 0, '1', '11', '', 1, '2020-07-26 21:51:44', '2020-07-26 21:52:10', NULL);
INSERT INTO `sys_menu` VALUES (352, 'Settings', '系统配置', 'system', 'settings', '/0/2/352', 'C', '', 'system:settings:index', 2, '0', '', '/system/settings/index', 7, '1', '1', '1', 1, '2020-08-18 21:44:58', '2020-10-28 14:21:31', NULL);
INSERT INTO `sys_menu` VALUES (353, '', '系统配置', 'system', '', '/0/63/280/353', 'M', '', '', 280, '0', '', '', 2, '1', '1', '1', 0, '2020-08-19 00:40:11', '2020-08-19 00:41:32', NULL);
INSERT INTO `sys_menu` VALUES (354, '', '设置配置', 'bug', '/api/v1/settings', '/0/63/280/353/354', 'A', 'POST', '', 353, '0', '', '', 1, '1', '1', '1', 1, '2020-08-19 00:41:01', '2020-08-19 00:42:25', NULL);
INSERT INTO `sys_menu` VALUES (355, '', '获取配置', 'bug', '/api/v1/settings', '/0/63/280/353/355', 'A', 'GET', '', 353, '0', '', '', 0, '1', '1', '', 1, '2020-08-19 00:42:47', '2020-08-19 00:42:47', NULL);
INSERT INTO `sys_menu` VALUES (356, '', '清空登陆日志', '', '', '/0/2/212/356', 'F', '', 'system:sysloginlog:clean', 212, '0', '', '', 0, '0', '1', '', 1, '2020-08-26 21:48:59', '2020-08-26 21:48:59', NULL);
INSERT INTO `sys_menu` VALUES (357, '', '清空登陆日志', 'bug', '/api/v1/loginlog', '/0/63/280/214/357', 'A', 'DELETE', '', 214, '0', '', '', 0, '1', '1', '', 1, '2020-08-26 22:02:16', '2020-08-26 22:02:16', NULL);
INSERT INTO `sys_menu` VALUES (375, '', '服务器状态', 'tool', '/api/v1/monitor/server', '/0/63/256/375', 'A', 'GET', '', 256, '0', '', '', 0, '1', '1', '1', 1, '2020-10-27 21:20:53', '2020-10-28 14:48:42', NULL);
INSERT INTO `sys_menu` VALUES (376, 'Server', '服务器状态', 'monitor', 'server', '/0/2/376', 'C', '', 'monitor:server:index', 2, '0', '', '/monitor/server/index', 8, '0', '1', '1', 1, '2020-10-27 21:31:27', '2020-10-28 14:49:25', NULL);
INSERT INTO `sys_menu` VALUES (377, 'Devops', 'DevOps', 'druid', '/devops', '/0/377', 'M', '', '', 0, '0', '', 'Layout', 3, '0', '1', '1', 1, '2020-10-27 21:37:31', '2020-10-27 21:37:55', NULL);
INSERT INTO `sys_menu` VALUES (378, '', 'DevOps', 'rate', '', '/0/63/378', 'M', '', '', 63, '0', '', '', 0, '1', '1', '1', 1, '2020-10-28 10:57:55', '2020-10-28 10:59:07', NULL);
INSERT INTO `sys_menu` VALUES (379, '', '流程分类', 'tree', '', '/0/63/378/379', 'M', '', '', 378, '0', '', '', 0, '1', '1', '1', 1, '2020-10-28 11:00:08', '2020-10-28 11:00:43', NULL);
INSERT INTO `sys_menu` VALUES (380, '', '新建分类', 'bug', '/api/v1/classify', '/0/63/378/379/380', 'A', 'POST', '', 379, '0', '', '', 0, '1', '1', '', 1, '2020-10-28 11:01:25', '2020-10-28 11:01:25', NULL);
INSERT INTO `sys_menu` VALUES (381, '/api/v1/classify', '分类列表', 'bug', '/api/v1/classify', '/0/63/378/379/381', 'A', 'GET', '', 379, '0', '', '', 1, '1', '1', '1', 1, '2020-10-28 11:01:51', '2020-10-28 11:02:07', NULL);
INSERT INTO `sys_menu` VALUES (382, '', '编辑分类', 'bug', '/api/v1/classify', '/0/63/378/379/382', 'A', 'PUT', '', 379, '0', '', '', 2, '1', '1', '1', 1, '2020-10-28 11:02:26', '2020-10-28 11:03:02', NULL);
INSERT INTO `sys_menu` VALUES (383, '', '删除分类', 'bug', '/api/v1/classify', '/0/63/378/379/383', 'A', 'DELETE', '', 379, '0', '', '', 3, '1', '1', '1', 1, '2020-10-28 11:02:51', '2020-10-28 14:03:07', NULL);
INSERT INTO `sys_menu` VALUES (384, 'ProcessAdminClassify', '分类管理', 'list', '/process/admin/classify', '/0/377/384', 'C', '', 'process:admin:classify', 377, '0', '', '/process/admin/classify', 0, '0', '1', '1', 1, '2020-10-28 11:11:12', '2020-10-28 11:11:40', NULL);
INSERT INTO `sys_menu` VALUES (385, '', '查看分类', '', '', '/0/377/384/385', 'F', '', 'process:admin:classify:list', 384, '0', '', '', 0, '0', '1', '', 1, '2020-10-28 11:12:24', '2020-10-28 11:12:24', NULL);
INSERT INTO `sys_menu` VALUES (386, '', '新增分类', '', '', '/0/377/384/386', 'F', '', 'process:admin:classify:add', 384, '0', '', '', 0, '0', '1', '', 1, '2020-10-28 11:12:42', '2020-10-28 11:12:42', NULL);
INSERT INTO `sys_menu` VALUES (387, '', '编辑分类', '', '', '/0/377/384/387', 'F', '', 'process:admin:classify:edit', 384, '0', '', '', 0, '0', '1', '', 1, '2020-10-28 11:12:57', '2020-10-28 11:12:57', NULL);
INSERT INTO `sys_menu` VALUES (388, '', '删除分类', '', '', '/0/377/384/388', 'F', '', 'process:admin:classify:delete', 384, '0', '', '', 0, '0', '1', '', 1, '2020-10-28 11:13:10', '2020-10-28 11:13:10', NULL);
COMMIT;

BEGIN;
INSERT INTO `sys_post` VALUES (1, '首席执行官', 'CEO', 0, 0, '首席执行官', '1', '2020-03-08 23:11:15', NULL, NULL, NULL);
INSERT INTO `sys_post` VALUES (2, '首席技术执行官', 'CTO', 1, 0, '首席技术执行官', '1', '1', NULL, '2020-10-28 14:20:41', NULL);
INSERT INTO `sys_post` VALUES (3, '首席运营官', 'COO', 2, 0, '测试工程师', '1', '1', NULL, '2020-10-28 14:20:45', NULL);
COMMIT;

BEGIN;
INSERT INTO `sys_role` VALUES (1, '系统管理员', 0, 'admin', 1, NULL, '1', NULL, NULL, '1', NULL, '2020-10-28 11:31:30', NULL);
INSERT INTO `sys_role` VALUES (2, '普通角色', 0, 'common', 2, NULL, '1', NULL, NULL, '0', NULL, '2020-10-28 15:08:14', NULL);
INSERT INTO `sys_role` VALUES (3, '测试角色', 0, 'Tester', 3, '', '1', NULL, NULL, '0', NULL, NULL, NULL);
COMMIT;

BEGIN;
INSERT INTO `sys_role_menu` VALUES (1, 2, 'admin', NULL, NULL, 1575);
INSERT INTO `sys_role_menu` VALUES (1, 3, 'admin', NULL, NULL, 1576);
INSERT INTO `sys_role_menu` VALUES (1, 43, 'admin', NULL, NULL, 1577);
INSERT INTO `sys_role_menu` VALUES (1, 44, 'admin', NULL, NULL, 1578);
INSERT INTO `sys_role_menu` VALUES (1, 45, 'admin', NULL, NULL, 1579);
INSERT INTO `sys_role_menu` VALUES (1, 46, 'admin', NULL, NULL, 1580);
INSERT INTO `sys_role_menu` VALUES (1, 51, 'admin', NULL, NULL, 1581);
INSERT INTO `sys_role_menu` VALUES (1, 52, 'admin', NULL, NULL, 1582);
INSERT INTO `sys_role_menu` VALUES (1, 56, 'admin', NULL, NULL, 1583);
INSERT INTO `sys_role_menu` VALUES (1, 57, 'admin', NULL, NULL, 1584);
INSERT INTO `sys_role_menu` VALUES (1, 63, 'admin', NULL, NULL, 1585);
INSERT INTO `sys_role_menu` VALUES (1, 64, 'admin', NULL, NULL, 1586);
INSERT INTO `sys_role_menu` VALUES (1, 66, 'admin', NULL, NULL, 1587);
INSERT INTO `sys_role_menu` VALUES (1, 67, 'admin', NULL, NULL, 1588);
INSERT INTO `sys_role_menu` VALUES (1, 68, 'admin', NULL, NULL, 1589);
INSERT INTO `sys_role_menu` VALUES (1, 72, 'admin', NULL, NULL, 1590);
INSERT INTO `sys_role_menu` VALUES (1, 73, 'admin', NULL, NULL, 1591);
INSERT INTO `sys_role_menu` VALUES (1, 74, 'admin', NULL, NULL, 1592);
INSERT INTO `sys_role_menu` VALUES (1, 75, 'admin', NULL, NULL, 1593);
INSERT INTO `sys_role_menu` VALUES (1, 76, 'admin', NULL, NULL, 1594);
INSERT INTO `sys_role_menu` VALUES (1, 77, 'admin', NULL, NULL, 1595);
INSERT INTO `sys_role_menu` VALUES (1, 78, 'admin', NULL, NULL, 1596);
INSERT INTO `sys_role_menu` VALUES (1, 79, 'admin', NULL, NULL, 1597);
INSERT INTO `sys_role_menu` VALUES (1, 80, 'admin', NULL, NULL, 1598);
INSERT INTO `sys_role_menu` VALUES (1, 81, 'admin', NULL, NULL, 1599);
INSERT INTO `sys_role_menu` VALUES (1, 82, 'admin', NULL, NULL, 1600);
INSERT INTO `sys_role_menu` VALUES (1, 83, 'admin', NULL, NULL, 1601);
INSERT INTO `sys_role_menu` VALUES (1, 84, 'admin', NULL, NULL, 1602);
INSERT INTO `sys_role_menu` VALUES (1, 85, 'admin', NULL, NULL, 1603);
INSERT INTO `sys_role_menu` VALUES (1, 92, 'admin', NULL, NULL, 1604);
INSERT INTO `sys_role_menu` VALUES (1, 93, 'admin', NULL, NULL, 1605);
INSERT INTO `sys_role_menu` VALUES (1, 94, 'admin', NULL, NULL, 1606);
INSERT INTO `sys_role_menu` VALUES (1, 103, 'admin', NULL, NULL, 1607);
INSERT INTO `sys_role_menu` VALUES (1, 104, 'admin', NULL, NULL, 1608);
INSERT INTO `sys_role_menu` VALUES (1, 105, 'admin', NULL, NULL, 1609);
INSERT INTO `sys_role_menu` VALUES (1, 106, 'admin', NULL, NULL, 1610);
INSERT INTO `sys_role_menu` VALUES (1, 107, 'admin', NULL, NULL, 1611);
INSERT INTO `sys_role_menu` VALUES (1, 119, 'admin', NULL, NULL, 1612);
INSERT INTO `sys_role_menu` VALUES (1, 120, 'admin', NULL, NULL, 1613);
INSERT INTO `sys_role_menu` VALUES (1, 121, 'admin', NULL, NULL, 1614);
INSERT INTO `sys_role_menu` VALUES (1, 122, 'admin', NULL, NULL, 1615);
INSERT INTO `sys_role_menu` VALUES (1, 123, 'admin', NULL, NULL, 1616);
INSERT INTO `sys_role_menu` VALUES (1, 137, 'admin', NULL, NULL, 1617);
INSERT INTO `sys_role_menu` VALUES (1, 138, 'admin', NULL, NULL, 1618);
INSERT INTO `sys_role_menu` VALUES (1, 139, 'admin', NULL, NULL, 1619);
INSERT INTO `sys_role_menu` VALUES (1, 140, 'admin', NULL, NULL, 1620);
INSERT INTO `sys_role_menu` VALUES (1, 141, 'admin', NULL, NULL, 1621);
INSERT INTO `sys_role_menu` VALUES (1, 142, 'admin', NULL, NULL, 1622);
INSERT INTO `sys_role_menu` VALUES (1, 201, 'admin', NULL, NULL, 1623);
INSERT INTO `sys_role_menu` VALUES (1, 203, 'admin', NULL, NULL, 1624);
INSERT INTO `sys_role_menu` VALUES (1, 204, 'admin', NULL, NULL, 1625);
INSERT INTO `sys_role_menu` VALUES (1, 212, 'admin', NULL, NULL, 1626);
INSERT INTO `sys_role_menu` VALUES (1, 213, 'admin', NULL, NULL, 1627);
INSERT INTO `sys_role_menu` VALUES (1, 214, 'admin', NULL, NULL, 1628);
INSERT INTO `sys_role_menu` VALUES (1, 215, 'admin', NULL, NULL, 1629);
INSERT INTO `sys_role_menu` VALUES (1, 220, 'admin', NULL, NULL, 1630);
INSERT INTO `sys_role_menu` VALUES (1, 221, 'admin', NULL, NULL, 1631);
INSERT INTO `sys_role_menu` VALUES (1, 222, 'admin', NULL, NULL, 1632);
INSERT INTO `sys_role_menu` VALUES (1, 223, 'admin', NULL, NULL, 1633);
INSERT INTO `sys_role_menu` VALUES (1, 224, 'admin', NULL, NULL, 1634);
INSERT INTO `sys_role_menu` VALUES (1, 225, 'admin', NULL, NULL, 1635);
INSERT INTO `sys_role_menu` VALUES (1, 226, 'admin', NULL, NULL, 1636);
INSERT INTO `sys_role_menu` VALUES (1, 227, 'admin', NULL, NULL, 1637);
INSERT INTO `sys_role_menu` VALUES (1, 228, 'admin', NULL, NULL, 1638);
INSERT INTO `sys_role_menu` VALUES (1, 229, 'admin', NULL, NULL, 1639);
INSERT INTO `sys_role_menu` VALUES (1, 230, 'admin', NULL, NULL, 1640);
INSERT INTO `sys_role_menu` VALUES (1, 231, 'admin', NULL, NULL, 1641);
INSERT INTO `sys_role_menu` VALUES (1, 232, 'admin', NULL, NULL, 1642);
INSERT INTO `sys_role_menu` VALUES (1, 233, 'admin', NULL, NULL, 1643);
INSERT INTO `sys_role_menu` VALUES (1, 234, 'admin', NULL, NULL, 1644);
INSERT INTO `sys_role_menu` VALUES (1, 235, 'admin', NULL, NULL, 1645);
INSERT INTO `sys_role_menu` VALUES (1, 248, 'admin', NULL, NULL, 1646);
INSERT INTO `sys_role_menu` VALUES (1, 249, 'admin', NULL, NULL, 1647);
INSERT INTO `sys_role_menu` VALUES (1, 252, 'admin', NULL, NULL, 1648);
INSERT INTO `sys_role_menu` VALUES (1, 254, 'admin', NULL, NULL, 1649);
INSERT INTO `sys_role_menu` VALUES (1, 255, 'admin', NULL, NULL, 1650);
INSERT INTO `sys_role_menu` VALUES (1, 256, 'admin', NULL, NULL, 1651);
INSERT INTO `sys_role_menu` VALUES (1, 258, 'admin', NULL, NULL, 1652);
INSERT INTO `sys_role_menu` VALUES (1, 259, 'admin', NULL, NULL, 1653);
INSERT INTO `sys_role_menu` VALUES (1, 260, 'admin', NULL, NULL, 1654);
INSERT INTO `sys_role_menu` VALUES (1, 267, 'admin', NULL, NULL, 1655);
INSERT INTO `sys_role_menu` VALUES (1, 280, 'admin', NULL, NULL, 1656);
INSERT INTO `sys_role_menu` VALUES (1, 344, 'admin', NULL, NULL, 1657);
INSERT INTO `sys_role_menu` VALUES (1, 352, 'admin', NULL, NULL, 1658);
INSERT INTO `sys_role_menu` VALUES (1, 353, 'admin', NULL, NULL, 1659);
INSERT INTO `sys_role_menu` VALUES (1, 354, 'admin', NULL, NULL, 1660);
INSERT INTO `sys_role_menu` VALUES (1, 355, 'admin', NULL, NULL, 1661);
INSERT INTO `sys_role_menu` VALUES (1, 356, 'admin', NULL, NULL, 1662);
INSERT INTO `sys_role_menu` VALUES (1, 357, 'admin', NULL, NULL, 1663);
INSERT INTO `sys_role_menu` VALUES (1, 375, 'admin', NULL, NULL, 1664);
INSERT INTO `sys_role_menu` VALUES (1, 376, 'admin', NULL, NULL, 1665);
INSERT INTO `sys_role_menu` VALUES (1, 377, 'admin', NULL, NULL, 1666);
INSERT INTO `sys_role_menu` VALUES (1, 378, 'admin', NULL, NULL, 1667);
INSERT INTO `sys_role_menu` VALUES (1, 379, 'admin', NULL, NULL, 1668);
INSERT INTO `sys_role_menu` VALUES (1, 380, 'admin', NULL, NULL, 1669);
INSERT INTO `sys_role_menu` VALUES (1, 381, 'admin', NULL, NULL, 1670);
INSERT INTO `sys_role_menu` VALUES (1, 382, 'admin', NULL, NULL, 1671);
INSERT INTO `sys_role_menu` VALUES (1, 383, 'admin', NULL, NULL, 1672);
INSERT INTO `sys_role_menu` VALUES (1, 384, 'admin', NULL, NULL, 1673);
INSERT INTO `sys_role_menu` VALUES (1, 385, 'admin', NULL, NULL, 1674);
INSERT INTO `sys_role_menu` VALUES (1, 386, 'admin', NULL, NULL, 1675);
INSERT INTO `sys_role_menu` VALUES (1, 387, 'admin', NULL, NULL, 1676);
INSERT INTO `sys_role_menu` VALUES (1, 388, 'admin', NULL, NULL, 1677);
INSERT INTO `sys_role_menu` VALUES (2, 63, 'common', NULL, NULL, 1781);
INSERT INTO `sys_role_menu` VALUES (2, 80, 'common', NULL, NULL, 1782);
INSERT INTO `sys_role_menu` VALUES (2, 92, 'common', NULL, NULL, 1783);
INSERT INTO `sys_role_menu` VALUES (2, 94, 'common', NULL, NULL, 1784);
INSERT INTO `sys_role_menu` VALUES (2, 142, 'common', NULL, NULL, 1785);
INSERT INTO `sys_role_menu` VALUES (2, 252, 'common', NULL, NULL, 1786);
INSERT INTO `sys_role_menu` VALUES (2, 254, 'common', NULL, NULL, 1787);
INSERT INTO `sys_role_menu` VALUES (2, 255, 'common', NULL, NULL, 1788);
INSERT INTO `sys_role_menu` VALUES (2, 256, 'common', NULL, NULL, 1789);
INSERT INTO `sys_role_menu` VALUES (2, 258, 'common', NULL, NULL, 1790);
INSERT INTO `sys_role_menu` VALUES (2, 259, 'common', NULL, NULL, 1791);
INSERT INTO `sys_role_menu` VALUES (2, 260, 'common', NULL, NULL, 1792);
INSERT INTO `sys_role_menu` VALUES (2, 267, 'common', NULL, NULL, 1793);
INSERT INTO `sys_role_menu` VALUES (2, 344, 'common', NULL, NULL, 1794);
INSERT INTO `sys_role_menu` VALUES (2, 375, 'common', NULL, NULL, 1795);
INSERT INTO `sys_role_menu` VALUES (2, 377, 'common', NULL, NULL, 1796);
INSERT INTO `sys_role_menu` VALUES (2, 378, 'common', NULL, NULL, 1797);
INSERT INTO `sys_role_menu` VALUES (2, 379, 'common', NULL, NULL, 1798);
INSERT INTO `sys_role_menu` VALUES (2, 380, 'common', NULL, NULL, 1799);
INSERT INTO `sys_role_menu` VALUES (2, 381, 'common', NULL, NULL, 1800);
INSERT INTO `sys_role_menu` VALUES (2, 382, 'common', NULL, NULL, 1801);
INSERT INTO `sys_role_menu` VALUES (2, 383, 'common', NULL, NULL, 1802);
INSERT INTO `sys_role_menu` VALUES (2, 384, 'common', NULL, NULL, 1803);
INSERT INTO `sys_role_menu` VALUES (2, 385, 'common', NULL, NULL, 1804);
INSERT INTO `sys_role_menu` VALUES (2, 386, 'common', NULL, NULL, 1805);
INSERT INTO `sys_role_menu` VALUES (2, 387, 'common', NULL, NULL, 1806);
INSERT INTO `sys_role_menu` VALUES (2, 388, 'common', NULL, NULL, 1807);
COMMIT;

BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', '18888888888', 1, NULL, '', '0', 'qq@qq.com', 1, 1, '1', '1', NULL, 0, NULL, '2020-10-28 14:20:09', NULL, 'admin', '$2a$10$cKFFTCzGOvaIHHJY2K45Zuwt8TD6oPzYi4s5MzYIBAWCLL6ZhouP2');
INSERT INTO `sys_user` VALUES (2, 'Victor', '13211111111', 1, NULL, NULL, '0', 'qq@q.com', 8, 2, '1', '1', NULL, 0, NULL, '2020-10-28 15:02:04', NULL, 'victor', '$2a$10$oDXQLs1W7n19sjc64bCpHeuti1jhN6r5hDz0iSqZRQMJE2eym2ec6');
INSERT INTO `sys_user` VALUES (3, '李四', '13838385438', 2, '', '', '0', 'qq@qq.com', 7, 2, '1', '1', '', 0, NULL, '2020-10-28 09:56:12', NULL, 'lisi', '$2a$10$DejldFea5.hGZGC7/oVN9OLDrHAWgu9l29RDz9FomLnWnro4umYl2');
INSERT INTO `sys_user` VALUES (4, '王五', '13535353535', 3, '', '', '2', 'qq@qq.com', 8, 2, '1', '1', '', 0, NULL, NULL, NULL, 'wangwu', '$2a$10$3.RT6rpXANXvvlibX6PzU.FGA2CvfDxd1UmJ2H5zTzF4sYocbvsTO');
COMMIT;

BEGIN;
INSERT INTO `sys_settings` VALUES (3, '2020-08-19 01:00:19', '2020-08-19 12:40:47', NULL, 2, '[{\"ldap_field_name\": \"givenName\", \"local_field_name\": \"nick_name\", \"local_field_nick\": \"用户昵称\"}, {\"ldap_field_name\": \"\", \"local_field_name\": \"phone\", \"local_field_nick\": \"手机号\"}, {\"ldap_field_name\": \"\", \"local_field_name\": \"avatar\", \"local_field_nick\": \"头像\"}, {\"ldap_field_name\": \"\", \"local_field_name\": \"sex\", \"local_field_nick\": \"性别\"}, {\"ldap_field_name\": \"mail\", \"local_field_name\": \"email\", \"local_field_nick\": \"邮箱\"}, {\"ldap_field_name\": \"\", \"local_field_name\": \"remark\", \"local_field_nick\": \"备注\"}]');
INSERT INTO `sys_settings` VALUES (4, '2020-08-19 12:42:10', '2020-08-19 13:22:56', NULL, 1, '{\"logo\": \"https://www.fdevops.com/wp-content/uploads/2020/08/1597815294-ferry_logo_white.png\", \"name\": \"Ferry 管理平台\"}');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
-- 数据完成 ;